package com.website.travle.mapper;

import com.website.travle.pojo.Spot;

import java.sql.SQLException;
import java.util.List;

/**
 * @author
 * @description 景点表
 * @date 2023-05-21
 */
public interface ISpotDAO {

    int add(Spot spot) throws SQLException;

    int update(Spot spot) throws SQLException;

    int delete(int id) throws SQLException;

    //    分页条件查询
    List<Spot> pageByLikeName(Integer page, Integer limit, String name) throws SQLException;

    //    获取记录数
    int getTotal() throws SQLException;

}